﻿ALTER TABLE [dbo].[Customers] ADD [LoginUsername] [nvarchar](max)
ALTER TABLE [dbo].[Certificate] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Certificate] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[CertificateStandard] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[CertificateStandard] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Customers] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Customers] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Equipment] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Equipment] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[QuoteItems] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[QuoteItems] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Quotes] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[Quotes] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[WorkOrderDetails] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[WorkOrderDetails] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[WorkOrders] ALTER COLUMN [CreatedBy] [nvarchar](max) NULL
ALTER TABLE [dbo].[WorkOrders] ALTER COLUMN [UpdatedBy] [nvarchar](max) NULL
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'201406031553138_Customer', N'CaltechSoft.Service.Migrations.Configuration',  0x1F8B0800000000000400ED3DD96EE43892EF0BEC3F24F2697650E3B45DD3859A823D03978F69A3AB6CB7EDEA59CC8B414BB42D948E6C49E9B631D82FDB87FDA4FD852175F21629514CA53B5140C12992C1603018110C4690FFFFBFFF77F0B797289C3DC3340B92F870BEB7B33B9FC1D84BFC207E3C9CAFF2873F7D9CFFEDAFFFF91F07A77EF432FBA5AEF71ED7432DE3EC70FE94E7CB4F8B45E63DC108643B51E0A549963CE43B5E122D809F2CF67777FFB2D8DB5B4004628E60CD6607D7AB380F2258FC403F8F93D883CB7C05C2AF890FC3ACFA8E4A6E0AA8B30B10C16C093C78383F06610EBDA71BDCC30D4C9F030FEE9C2268F9EBD93F7610A01CBEE4F3D951180084DB0D0C1FE63310C7490E7284F9A76F19BCC9D3247EBC59A20F20BC7D5D4254EF018419AC46F4A9ADAE3BB8DD7D3CB845DBB006E5ADB23C890C01EEBDAFA8B5609BF7A2F9BCA126A26749293CEA82A6889C30CD8387C003393C813908C26C3E63BBFD741CA6B84907F1CB3F767888EF668276EF1A6E424C87FFA15AAB305FA5F03086AB3C05E1BBD9D5EA3E0CBC9FE0EB6DF21DC687F12A0CC9D1A0F1A032EA03FA7495264B84C2EB357C908EF1DC9FCF1634A4050BAA01A48452D2E53CCEDFEFCF67170841701FC286A1081ADEE4490AFF0E63982200FE15C87398227E38F76141360E1F79EFDDDD6A83BAC941EC83D4370679019E83C7626072E0F3D9350C8B3AD953B02C1723C91D7722DE3B4B93E83A096948829A77B7207D8468A5DF265AD56F9255EAF51B474DA4AEF1D4F5F4C7A568A11A9FAA99689C078B76D9EB0A038B526042CB7FE0BA5FD382BF48EA6E91EE428A793EFB0A5EBEC0F8317F3A9CA33F1177052FD0AFBF54A87C8B03A4C751A33C5D75CA847F24E9F7CBD487A983BE8E0BC682E9503976FAEB2A5846889A83056212FB019EB36BE8C1E01912E2703C22B47D22A68F9DF4790BA325E646B4C846EFAB1495CFF0C75514F805BB8F4D501006F769B1F48E5FBD70FC11121D9E1402B3EC0FFF7D8B6C5B632EBC4086EBC90A5A8155090FE87F1E9FF0B748B2A3FA018847EFEA67B44340BC741E674BE821F13A7A875F41BC7A001E5E31E3777602332F0D96A5A13FF6C0F03EEB6215DD3B1817D2F868A7E5A8B3AB4B571DA589077D17A2F428CB60EE6854D7683F997ECFC6179E29C4569103F154F52416ABEAA6DF96FEC0A6638C4F67CBD26C3BC6DC81D55B0DCD1D58BDA119BA3369B763D6762835C809ED54C89DF9801D8BFE06DFDECEA5EED3C156C2A97E7EB33AD396D5790BB3FC1A2E93D495B6DA6A91296811BB7E2F8556D17197F5D32E954762B04AA9E0AC5B8FF4511A2E3504FE7F7CB3D9F753988D6FCADEC2D081EAB90F5CB834923847DAF40AF169123B99A4D308ADDED17B39C35046EE43E9BE5137FD923C06F1B70C2D211724DF2A4DFB4AB371458B9565537CD76A9A5631F2A5DCE18FA0CAA0839E06DE508DD700DAAABC09ED54B69EC4AD2751D4934B4F62E7F1C868EAD489E1223DC4DC2A5FE73BD646A7DA50BDECFE53A19D7BA9DE9F57490ECF73180D55BD0DA0ADEAED3C35ACEA0D091240CC995FA5810709301FFEBCBEA08572FA87463E6CC5D1787B01A13C6A56ED1D51AF154882624E2289EA8844920AC902861CC13B0C3EE3102B3F73BB13B26CD0B6A4C2CA825CDCCA440DE9D1674555A43C7EC23C900D9385B7AD5BA61F806214AEECD9245A82F875A8C4BD0121CC106F2BC3BDF6F63F6E1D3D9314EE15172824675383959D5581589C37A5A682BC12D4FD04B918155AC8EB225233B60297B60A8B4E5D22C1A8291E6479630FEB50E582616CB66E19206E8C8F831D78F68334CB9D6CF8BF00471D7D0EC2104176757C55757775F93919FF90A4EAEC9FC1F218B571D5DDB18BF8E3BAAF6415E7E9F8DD9D6727308448FDD53D7D4E90C0C4B2D57443DA7102B7FFC3075BE77CC749FC10A4D1709CAF4096FD96A4FE8F207B72E074F65629E2A09B1C44CBF19DC14F49ECCAA425FAB23635B7BF256700C7669FC6B8D560785F12EF7BB2CA4FE3C244FC967BE687AB15002BE81C791E12CA678899A15F2CF5814E25644E742815DDF5D73F632F0481C484C4E8DDD5E5ADCD467CE60C36B2CCD4842CCEC11598D4E50C26E56731265599292618820291AA98C1A3F82A46A32C1A64BDD63B7B0CAFA0AFCA94FDDA24041F65CB0B98EFD4AD6B833645309104FDBEC3817D37D36EDCDABCFBBA36EFFBBDFB87F71F7FF800FCF71FFE0CDFFFF0167D2B9894EBB0B78BE9C39D8EBFDFC73DFD02C295EDAE7AAD86628DDB5F0D05D8E9AF86024DF4F939F0B1C9B0E86E515746E0B5EAD7FC6CBAE618CC5C2F076A98AE3B7723037A2D17AC8BECAF160C75FA8B45CCCAC2AA78407DB87E5DD2BFC677621C679FDB3683D336C549B7EEDD075E2E624B9B9CEFBBAA5A6B71F3A59CE52DA832C802BF85E9E0A00D0C63DDFE638C431FF6ACDBB9B2A3717F4E3CAE2EC325A9109213E8051108E7B3AB14FD555DC18596F98D0730453BA3C9CEB38225B22753C78636CF37F78258BA1C8A85B7EEB530F5BDA4B570A186F0DB90A1E99D2AAB4386D835238E1C92D7E214A3A2AAA9A3AC01A5C6FC8E972302CCB95A5CA491A2EAA0C023621896E4DBBA051BB5DE4D259C81B0B027EA36F10AAAEDA543EB4898D8C6506DB4B653C550B5025E1047C515CA355BEF782A6518530B5E14CAC4972AF053863469695C5576FE60C52B475CAAA37514EF5196255E50605B330354DE464313E534F6676657D3943CCD5C5880B81B69DD6089F42CC211898A39AB4F2FE332BA6276E495D7F61E83CC033ECFE4689C7E4F1C1BDB468863335D34AA7FE430402A1FA658C3021C5F912123228873DE3E08622F5882D0887C0C14A19DA1BC5C1313A8E99A2D39814B1863DBC0885C56706ABA6626B38B96070B8281B5F95A753F8606EF685D9621E4A1F6A624D7FCAE75B1ED7AF95E83AC86BC26BFB2A9EF3AD020A3551C1DAC0B413E9E8C9F54C9792DEF109BE12E96518216B16593314843DEDDD9D9B3C38F723C74E67520A3C9E9ABC554C4166A2D9C24CAA492CDB732ADAA9D702237539F9754E9583A7C6A551AF7E242C5081CB0A1626E747AA73CA4EB63C466BFA264137EE3C2309F31E3711B1D0DF935118E635177C56BEC246849BB36FB6B8D3C5626F3A8F981C9ECE9E0AF914C4161B6682F393B80BD284A38632E6AD03ABD3689DC6B612C32C457369BC278DF7636CBBC2A277C258A2E263011C4C88EC25F028238E02FC1E0757A95C63C3963AF2A6E5B39A96C10F7FAD88B091997B05715743A1E7BD10471C55EF4E03783BDCA687CE59C32A1F9EB632E3A1140C25B65CCDC78AC4551C3156751239F3C633109CB6A3B8777F70FB6EAB9E3810E9EB5E79210F7EFCC7C6269A9D331791EB8166E11842ACAA65715B7C84B03912418493C29A225DD8B2939951C30A29C123A9D8BE3C61D31A222544836EF3A7143EDFCF3C789FA924D23EC6833FC65DD0371C0A5DDF3B619DE33FEC4BF937F545E342292AB07676EA6374D8ABE4B36ECE5555BF7198220A0A39B4754E6DE40F65B9FD927C7C129136DA4F9A788B6E99E7279E88D06578D640BEA44E40EB1090672A88C643ACCA2888BEDC9B2321259C0C63AEF965159C5330F410CD336A814472A378FA77321D048F45451D05915ECC7720E067B03733EE0A0220ABE2EA10D0953847D7042520AB903A209A83A2AA203641B4FD305BAD26B42788D19D101847C5380834258C71D6088B3160E0A51A603458448E5DFE8685EA5EF71AD4B9DD6D198F3EA8B20095CFF0660EB9B4594602B97AF01D8EA9E1025D47217DD01B40B9016109C4F270252E6357634E6853C0787AFA20B53098D0343C836E16A16BE434534E2177667641EA51D35634F9BD1B2528B93F3C621A362D084A865753D4D3233722A9FF75292553BF05146039DD047312D0889AE476E9D88C5F1C92EBAAD9E2771570C1D354645141D311E52D92808A6889B2389D3AABFC11411DE97CD93A433188CF7B14BC2C1887148D56327300151E414EE4B95364542420FB1474570DAC0FA53581AA899421C8734263FD4B7DACAC62D889311604C47CAF419331DE0A2C3393D464C5DC2C68F581AC041E12B0AE120F0ADEC33C5804591170400918D6667E4B5692619B928B680479C892E301F3913142019798DAB9D9157469F64E082536F1E6DFADCDB7CD8F471B564D4159E9696769B59255BDD62579D6079728EBA3E6B9C73C97551B1C7C845579DF0A3EF3A65D43D672406209C3ADD63C191D94195F6CE1347F7E4CBF4EC8B1864D7FEC6F4B06B2CE3409043A9A0978691203F78115147932EAE0C0651CEA68A1C1AD24571143084202E248D2A31544515B563DBD4B53D844A528FB4C14A5510AECE5C6D7CA44DD9C1E2C67B8211A83E1C2C50150F2EF315088B3710B3BAE02B582E83F8316B5B565F66374BE0E16DE79F6EE6B397288CB3C3F9539E2F3F2D1659013ADB899A6BCDBC245A003F59ECEFEEFE65B1B7B7884A180B8FA23DEBD16D7ACA93143C42A614C7B1FBB0B833FF04E4E01EE02CEE633FE2ABD11E61891BA7EE4CE1F4E567B476F3D48DF1DF941B5A7CBF46858AC867CC3BDA2BD867880458A816D480CADD3B0F0481C1D7308194CD5EE7DA62DFFD7112AEA2585583656EAD1E14A07BC324530025B055598298F319FA72E716DC2C73474F340799F2D7B87C358CA17A71D218F38CAF5191C0C445FA30A98B5948885481018EC4A93F85A0221A400E8D8A6021C129435B14D825B11F60BD700D3D183C437E9D882AF4829FAFD25809BFADA00FFF16464B7C034FF19E2C09972AD08757DE2EF10C7F5C4501C2EB9506CA971A5082BB3C87220357DA0B7279298A04F089E09C500597BA2D8784491518AFD6F2FE15C15A2D0B4CE6DE7B8A0364D7C4ECD4B7DFF5A1FD8C2C1B34A5E771B684F845071A265FAA0F997E0C9B844A97E843A4AE7024015205061892AF5A53089205FAF0E897AB498074893EC4F6B625125AFBD50052FBFE3405AAFDAC0F8B7A619A84461598489F08A4DF3356E8541F0D565A7B8F13B5CEDACFC6B00492852CD087475DDF44C2A30A8CE1B163253E4FD1A66B4FECC6B4ED9A108E41369E1C8A0BFB5B2A63AA56AC99467E5FA78C9EBE4C15EAF61E7AFD1666F9355C26A95014F2A55B39B6E972AC7158DA175E92237E1D89256D2A23392B93CC0410FE9FB18B017F05A10A42F3E821653AD41F4D1660C8AEB9D04C54DD07EC86A4FE66B4D5CB919CBC427C91C43C7104C506DBDEF2D93E6AC35B7ED28771862F762421141FD6B71D2A8E4FB1A73BE668C5146D05E6860B4CE2C0CBBAC4949EFC69884C45DB7164E6762BBCDD0AEBC1DB14A7D6702BC0AE8378AB0126A901DA1039EB0A400A5A430128DA8EA3007E5E8138E7FCEAED5783C98F83BC7A5E869AFCF6F3FA4E559A4BAEE8414A6EBE92C3D92EE6E92EE6114CB932BBA8E72A76B7825167FCAC139F8D8C234C89E3271CD49271E6115566B01D66377AB7661BBD62282253862A30D91837B729D21B62E9258B0A8A11D9BF14B51459C10ACCB6F2658AF24516ED3A50BC14E987E6D245DC6C1CE132D49355047BF12639F1D9C03F0344A0DAAFFA903E076188282C74F7B165C650AF2E3F272F4298558931C47F064B1C382784D99419433DE6AC3EAAC01C5EB28AF35402B22ED3877A9E953709B0ECDB7E76EBAD2C1AA095FB10A4118B145B66B0E30759F65B92FA3F82EC89D9F45325262ADC5BA55854E4205AB21A9C2A32C0F22989850A982AE8054F4251710D03B9F55B7206705CC8698C9F9062A0F3A5265E62EF7BB2CA4FE342E17DCB3DD653CC15F7802DC0992D33F004791E9264678845A15F2C44C61FC4171B2871A48B7899DC7E9D8C0A17648859D7E7FC2500E6CA5D03C6389ABEBEEF929D47430316A38CC9C6989CED674358BF80702502567D9F247F4993022DF257791BC430FE92C0509E8FA16FCF81CFEA01A6C8C8E35DB4F909328603553016174F80576479941659A5B89D6318A788418C2B4AEA9B2CA9D03BC9ED966B9BCA91A76FE0D4994D9BABE88B354D5579FF8CF5A92AAEAF319F227133F9363C8DD8E9A9BF996CE6EB17ED5938A61B68DB87BC827303E33303EA357A7ACB48144C861D35521A077266570F1A5CDA0D621C6162FBFC87BAE84E9843B4F5D3BE013F2D91CD3BDE6A1AB28CF4D78F6D8E9D7616DDF1EF3E17CB5E10D1F644EACD483AEE3600B64AD37BF5A5F9DDDC065065E253570414E3C709FFC5B8B3EA56003635BFAC329FD53B71C441AF590EA31D5C61E7E6D7F0380C70A46253E12B88830798E5B7C977181FCEF777773FCE67476100B2F23E87EAD2814FECFDAE5AB710ECBDC7B710403F5AB0CDCDEF32C050B2CC0F053719E069AAB915AAB3F40F7E82AFEC64D70C257CFC569A8D7FB060411DB02B4708A5BCAE32C07350689CBFC31867D842FF0AE4394CE37623389F5DACC2107B8E0FE70F20CCF8DB3AE51D323D71B7F39EC73E7C399CFFAB68F96976FEDF7754E377B342BB7C9AEDCEFE67081A6452526F745A200668C95E935771CC405619C823EE98031B0D654FF13348BD2790FE21022FFF45822C2E6CEE8048192116E09156084108C371529B8DFE608419FB360629CAD4B70097CAD4B7008F4FD2B73178CE26B40BB4B41D4A9858FDE701F69018CE3C650B0E8445E5E45B99E53629DF02383E1FDF02503A07C10240CA3D6503413207C1023C3A05C102C076036103589B8760011A95876045CC5469F9360441BBBDB107AD4B0CE880A276365640F51A631F93489CB56E6C1AC993D38D4C24893969DB542293DFA72810272FC06CA94F3EEB7D2B2626242684A9E27AB2A18F201879D597C7693674641D856AC5E00B2D898C3211DDCE0E864D41B700B50AEDB400A94848B70047731FA0038AC944DF0AB1E90831D963A79B2AC5B6BBAFEDEE6B0CD7896389694DAF489C8A3A1EE8A6A5CCEDBC15D40E05B524C97A6305759BADDDDF494DA4699740EE83479B3E738D5542341D7468D4E4759B755F351B765EB55DA21697E89B599E4D26F630CAB319D88316EA6DBBB7E90981CABEB6B21B6CF2AF0DD56BDD70D0DA25E363E8D16821D136A7B1F80A5EBEC0F8317F3A9CEFED7FDCEAFC3509143E69DA853C693948CE069AEE4B4B1E8D36F1DA02B436F7DA023036F1DA1EC82AEFDA1EC026E9DA1EC8635B07E36CC6B5059044CE75AD307A188622AF1CB52EF67FF8D0CBD5472408F7478F4EB7B6E24CA092AD6D3800C8646BBBF0AC9090CFAAEE0F4B90463DD46F4AA74FF7474D902F3D60DBD5644A9B9A1C75CBE2F3BBD979867670BFAE50C12DA2066378302B6B488C5B477EF2C61AE9757E620FCBAF6CAA6BF5E9ED23DB7C691B661F91303D9E85D59159ACC7191D89C4821657AA4461417D71226A37FF319859B6EFA8515886BD4ED6EEC53D7CDAAA1EF3C8728C0555C589C4DD5C302D31518FA2073665539733DB775627B203EBA7A5F1A0D7A0A5F9EC623D5A8B738ABBE95DB71B5141B769CA133C89A43CE73EF4820884383106FD9515192E7B88E170CE112ADE37DF7E11F9CBBA76AB36ABA8537C37D69E9BC0390495A9698602D1747B1E3105F7A12483576F79285276BBD7898C8B6C2F18472938564ECBF578FFF796216235DA647B1AF286C419F1DC783D76D844C2DF7526BAB6EFA093198E157AC54BEDD4F7AFAB300F9661E0214CD0347357315CC6A53B7976E495E9BFC720F3007F87291E8DAF8149F3CABA18A1A698C6EB8F5C774860C3144B4F805DCA599E82804FE746965EEC054B100A28C2D415EA828EA7950F164D076CC9095CC2184B773905AC20D0F4C34C461779A857EDB5B9AF4E90E8C9854D528964F2DBF2DF2B572A9E9C543287EA1148A75CAA46C401B736FB813B499A0231FF75056AD69B8FF45CEFEEECEC71D3DDC26AC3894960C4D7713847FEDE9FCEBECF8837542F6509584271B38C133E68C206EF6491DEBD276F2471D4063A9258105F476121B3691DC843AAC776F8CE94D787B963A23A62C98E1C19937978C679037247F6AC8B40E6C89F0471C82D98BDE5D690E63CBD2911A33F834EC58BF4452927CC820F98EE44779B13D35584C19133557E70C22A7CE8008988A07414D6913CBA629D73742E833738C274C640A2CBCB27C8406584818C81AAD237C340B2DBDEA7C840822BB127C83FC569B48C7DCAC237C33D925BC427C63CA5AD533B8E873150C7D6DAAD69EB6ACAF58D22D555A04EE69A8C09B913BCAE2658B4D2052B5AAC6F5880743C0D300D41227BA7C10973B1110D1BE3AEE142314864F8C2CD77DE68DC503F451F4E83F646F871DAD005213BBD017F8EEA6AF609FA915BF67162ECAC67FE5D193D6673BF76C3A79DFB8EB8BBDEF3F7867593D95C2B1F4A185B4975746E9DD34EE97BE21BF73573A73BC764D5D5F3FCA96B33936D4489E210BBBC2BFE70EEDFE3E0B1323C45548F1352D2FED51D77F668D2551B23A0EAB2ADD5D1755BB10B85C60EE0FB6D8A849D55A5DD04252C58AE0FA24CD40951DCD109E1ECE73A21CA449D34C5DD43A976E8E21E14D0BB21973A95035C7E16C13DCA9617302FB7AD5DC0056E6DAE27411D75B79593DFA4EFCA23AAECBBAAA3EEBBF20F9BF45DEE86955D9755D43D978E45DD8E3B3AEDEA50AFB322CF82EFA4FC2C025E967440E5D529D7035F45D41B5F4BB76755971D7DF1BD103A4B288045B15F33A2112F8C3BA3C5E85D18AF568A679914FA42D69E9911168C8CCE0B9A0466E45185C8A9C9A41D5C271B2EAB1AD9F1CA74DDDAC92788D91290AA2BB24BB29727916F3E2A08C069E1A2A95CC19A0F57149A24186F6704D310B4790F3B6913146D89AF7686DC38606483157B682CCD2B6592B403B436B8CA30920D4D1016D2073DC7F34646290886260D6210F845080CCB0F8A8149ED30C9ABEB96065A5B4B92814A5F0AB73350CAE8933CFF6D69A095BD2419A7EC99643BC3244D3DF1D3D5B65664E3B0932E4AB14B6FE060C71334828338C1D0BA8EEB140776825911CDC85AE7567160242086EEF192355D2ADB0E885FE8B5480E9576ED3803B1A461B9FD08F39CAACDC1AAD67697CB7EE0FA76394C9E6154C3D578A5BAE7209CB038F780665376B02837B1D507F4937B28F36071BD8A710A5FF9EB0466C1630BE200C18CA14739629B3AE7F143523B85198CEA2A4CDADF5734361FE4E0086F86F09B08F8B6EF2C0BE2C7F9ACB8BA075F76760FFDF3F872952F5739BEBF3BBA0FA93B6FB05F59D5FFC182C3F9E0B2B80421B3310484668073172FE3CFAB20F41BBCCF04B713484060877595D38CE732C7B9CD8FAF0DA48B24D6045491AFF1B3E337ED42042CBB8C6FC033EC831B5AC55FE023F05EDB4B806440BA278226FBC149001E531065158CB63DFA8978D88F5EFEFA6FFC68E12E2E490100 , N'6.1.0-30225')

